package com.idcf.boathouse.product.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.idcf.boathouse.product.models.TravelOrder;
import com.idcf.boathouse.product.vo.TravelOrderVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @Author Leon.xie
 * @Date 2021/6/27
 * @Description
 */
@Repository
@Mapper
public interface TravelOrdersMapper extends BaseMapper<TravelOrder> {

    @Select("select * from orders  order by update_time desc limit #{limited} offset #{offset}")
    List<TravelOrder> queryOrderList( @Param("userId")long userId, @Param("offset") int offset, @Param("limited") int limited);
}
